OS. ActiveX Component in Microsoft® Excel
Error message:
ActiveX component can't create object
when attempting to run an OpenSTAAD macro in Microsoft Excel.
If so, make sure
you click
Yes. If not, you need to change the security settings in
Excel. Select
from the Excel menu. Make sure the
Security Level
is set to
Medium. Close Excel down (completely, not just the file)
and reopen the file again. This time it should ask you if you want your Macros
enabled or disabled. Choose
Enabled.
OpenSTAAD DLL not registered
When you run your macro, if it still gives you the error ("ActiveX component can't create object"), it might be because the OpenSTAAD library was not registered properly when the program was installed.
Register the DLL
- In Windows Explorer, go to the following location: C:\Program Files\Bentley\Engineering\STAAD.Pro 2023\ STAAD\Plugins\StrucLink\.
- Search for the file: OpenStaad.Registration.exe.
- Right-click on the file OpenStaad.Registration.exe and select Run as Administrator from the pop-up menu.
- Click Register OpenSTAADUI to register the DLL. A message dialog opens indicating that the OpenSTAADUI type library is registered. If the registration did not succeed, please contact our technical support staff for further instructions.
- Click OK.
- Try opening and running the Microsoft Excel beam example file provided with your STAAD.Pro software (C:\Users\Public\Public Documents\STAAD.Pro 2023\SamplesSample Models\OpenSTAAD\Rectangle-Beam.xls).
- Close all the STAAD.Pro instances and open only the relevant STAAD.Pro model.
- Run the macro.